package com.example.qxfw.hbqx.mapper;

import com.baomidou.dynamic.datasource.annotation.DS;
import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import com.example.qxfw.common.entity.zy.AirHazeWarn;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Select;

import java.util.Date;
import java.util.List;

@Mapper
@DS("service")
public interface AirHazeWarnMapper extends BaseMapper<AirHazeWarn> {
    /**
     *根据日期段查询霾预报产品
     * @param datecharStart 起始日期
     * @param datecharEnd 结束日期
     * @return
     */
    @Select("SELECT * " +
            "FROM air_haze_warn " +
            "WHERE DateChar BETWEEN #{datecharStart} AND #{datecharEnd} ")
    List<AirHazeWarn> selectByDateCharOfAirHazeWarn(Date datecharStart, Date datecharEnd);
}
